*** Table C4
use "data\in\customer_payments_extrainfoSept23.dta", clear
keep if Treat == 1
drop if noncomplier==1
replace wattmeter = 0 if wattmeter ==.
replace pdiff=pdiff/9.5377  // convert the bill difference into USD using nov 1 2020 rate
gen pdiffm=pdiff/(3+11/31)   // convert from the (3 months + 11 days) of the experiment into a monthly bill difference
sort pdiff
xtile x_pdiff = pdiff, nq(3)  // create terciles

bysort x_pdiff: sum pdiffm
bysort x_pdiff: tab income_q
bysort x_pdiff: tab wattmeter 
bysort x_pdiff: tab elbil 
bysort x_pdiff: tab pre_forbruk_q

